CREATE DATABASE OnlineFloralDelivery
USE OnlineFloralDelivery
---------------
GO
CREATE TABLE Occasions
(
	OccasionId		int IDENTITY(100,1) PRIMARY KEY,
	OccasionName	varchar(30) NOT NULL
)
GO
INSERT INTO Occasions (OccasionName) VALUES
('Anniversary'),
('Birthday'),
('Christmas'),
('Father Day'),
('Mother Day'),
('Friendship Day'),
('New Baby'),
('New Home'),
('Teacher Day'),
('Thank you'),
('Valentine'),
('Wedding')
GO
----------------
SELECT * FROM Occasions

CREATE TABLE Bouquets
(
	BouquetId int IDENTITY(100,1) PRIMARY KEY,
	BouquetCode varchar(10) not null unique,
	BouquetName varchar(20) not null,
	Price money not null,
	Quantity integer not null check(Quantity > 0),
	LikeCount integer null,
	ImageUrl varchar(1000) not null,
	OccasionId integer not null FOREIGN KEY REFERENCES Occasions(OccasionId),
	[Status] bit NOT NULL	
)

INSERT INTO Bouquets (BouquetCode, BouquetName, Price, Quantity, LikeCount, ImageUrl, OccasionId, [Status])
VALUES
('BQ001','Rose',10,50,3,'C:\abc',101,1),
('BQ002','Tulip',13,50,3,'C:\abc',102,1),
('BQ003','Lan',10,50,3,'C:\abc',105,0),
('BQ004','Mai',10,50,3,'C:\abc',107,1)

SELECT * FROM Bouquets